var UserSQL = {
    insert: 'INSERT INTO User(username,password,isvip) VALUES(?,?,?)', // 插入数据
    drop: 'DROP TABLE User', // 删除表中所有的数据
    queryAll: 'SELECT * FROM User', // 查找表中所有数据
    getUserByname: 'SELECT * FROM User WHERE userName =?', // 查找符合条件的数据
    orderByASC:'SELECT * FROM User ORDER BY ? ASC;',
    orderByDESC:'SELECT * FROM User ORDER BY ? DESC;',
    fuzzyQuery:'SELECT * FROM User WHERE userName LIKE'+'%?%',
    delete:'DELETE FROM User WHERE id=?;'
};
module.exports = UserSQL;
